.class public Lcom/waiqin365/lightapp/dailyreport/a/a;
.super Landroid/database/sqlite/SQLiteOpenHelper;


# direct methods
.method constructor <init>(Landroid/content/Context;)V
    .locals 3

    const-string/jumbo v0, "dailyreport.db"

    const/4 v1, 0x0

    const/4 v2, 0x5

    invoke-direct {p0, p1, v0, v1, v2}, Landroid/database/sqlite/SQLiteOpenHelper;-><init>(Landroid/content/Context;Ljava/lang/String;Landroid/database/sqlite/SQLiteDatabase$CursorFactory;I)V

    return-void
.end method


# virtual methods
.method public onCreate(Landroid/database/sqlite/SQLiteDatabase;)V
    .locals 1

    const-string/jumbo v0, "CREATE TABLE  IF NOT EXISTS maininfotab (id TEXT,promulgator TEXT ,promu_name TEXT ,promu_pic_path TEXT ,small_promu_pic_path TEXT ,promu_pic_upd_time TEXT ,published_time TEXT ,terminal_type TEXT ,content TEXT ,info_type TEXT ,info_type_name TEXT ,location_a TEXT ,comment_times TEXT ,cache_type TEXT ,score TEXT ,surper_code TEXT ,work_id TEXT ,work_type TEXT ,PRIMARY KEY(id,cache_type));"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    const-string/jumbo v0, "CREATE TABLE  IF NOT EXISTS pictureinfotab (id TEXT,info_id TEXT ,picture_path TEXT ,small_picture_path TEXT ,cache_type TEXT ,PRIMARY KEY(id,cache_type));"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    const-string/jumbo v0, "CREATE TABLE  IF NOT EXISTS commentinfotab (id TEXT ,info_id TEXT ,commentators TEXT ,commentators_name TEXT ,commentators_pic_path TEXT ,small_commentators_pic_path TEXT ,commentators_pic_upd_time TEXT ,terminal_type TEXT ,comment_time TEXT ,comment_content TEXT ,commented TEXT ,commented_name TEXT ,commented_content TEXT ,commented_info_type TEXT ,commented_info_type_name TEXT ,cache_type TEXT ,commented_work_id TEXT ,commented_work_type TEXT ,PRIMARY KEY(id,cache_type));"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    const-string/jumbo v0, "CREATE TABLE  IF NOT EXISTS modelcachetab (model_id TEXT,time TEXT ,pic TEXT ,pic_selectedalbum TEXT ,PRIMARY KEY(model_id));"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    const-string/jumbo v0, "CREATE TABLE  IF NOT EXISTS formatdatatable (model_id TEXT,view_id TEXT ,value TEXT ,PRIMARY KEY(model_id,view_id));"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    return-void
.end method

.method public onUpgrade(Landroid/database/sqlite/SQLiteDatabase;II)V
    .locals 1

    const-string/jumbo v0, "DROP TABLE IF EXISTS maininfotab"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    const-string/jumbo v0, "DROP TABLE IF EXISTS pictureinfotab"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    const-string/jumbo v0, "DROP TABLE IF EXISTS commentinfotab"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    const-string/jumbo v0, "DROP TABLE IF EXISTS formatdatatable"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    const-string/jumbo v0, "DROP TABLE IF EXISTS modelcachetab"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    invoke-virtual {p0, p1}, Lcom/waiqin365/lightapp/dailyreport/a/a;->onCreate(Landroid/database/sqlite/SQLiteDatabase;)V

    return-void
.end method
